SELECT IFNULL(cw.casedwordid, w.wordid) as wordid, IFNULL(cw.cased,w.lemma) AS lemma, ss.synsetid, ss.lexdomainid, lex.lexdomainname, (CASE WHEN ss.pos IN ('n') THEN 'noun' WHEN ss.pos IN ('v') THEN 'verb' WHEN ss.pos IN ('a','s') THEN 'adjective' WHEN ss.pos IN ('r') THEN 'adverb' ELSE ' ' END) AS pos, syn.definition AS definition_indic, ss.definition as definition_en, GROUP_CONCAT(DISTINCT CONCAT(wind.lemma,':',wind.id) SEPARATOR '|') AS lemmaset_indic, GROUP_CONCAT(DISTINCT sm.sample SEPARATOR '|') AS sampleset, GROUP_CONCAT(DISTINCT CONCAT(IF(IFNULL(cw1.cased,w1.lemma) = "Jesse Jackson", NULL, IFNULL(cw1.cased,w1.lemma)),':',wen.id) SEPARATOR '|') AS lemmaset_en FROM sqlunet.wnwords w LEFT JOIN sqlunet.wnsenses s ON s.wordid=w.wordid LEFT JOIN sqlunet.wncasedwords cw ON (w.wordid=cw.wordid AND s.casedwordid=cw.casedwordid) LEFT JOIN sqlunet.wnsynsets ss ON ss.synsetid=s.synsetid LEFT JOIN sqlunet.wnlexdomains lex ON ss.lexdomainid = lex.lexdomainid LEFT JOIN sqlunet.wnsamples sm ON sm.synsetid=ss.synsetid LEFT JOIN sqlunet.wnsenses s1 ON s1.synsetid=ss.synsetid LEFT JOIN sqlunet.wncasedwords cw1 ON cw1.casedwordid=s1.casedwordid LEFT JOIN sqlunet.wnwords w1 ON w1.wordid=s1.wordid LEFT JOIN sk_synsets_ml syn ON syn.synsetid = ss.synsetid LEFT JOIN sk_senses_ml sns ON sns.synsetid = ss.synsetid LEFT JOIN sk_word_ml wind ON wind.id = sns.wordid LEFT JOIN sk_word_en wen ON w1.wordid = wen.wnwordid WHERE w.lemma LIKE "Jesse Jackson" GROUP BY ss.synsetid,w.wordid, cw.casedwordid ORDER BY pos, wordid
[
{
"lemma": "Jesse Jackson",
"def": [
{
"l": "Jesse Jackson",
"lexname": "noun.person",
"lexid": 18,
"pos": "noun",
"de": [
{
"id": 111096556,
"en": {
"d": "United States civil rights leader who led a national campaign against racial discrimination and ran for presidential nomination (born in 1941)",
"w": [],
"eg": []
},
"ml": {
"d": null,
"w": [],
"eg": ""
}
}
]
}
]
}
]
Sorry, exact match is not available in the bilingual dictionary.
13
What is another word for Jesse ?
What is another word for Jackson ?
The word or phrase Jesse Jackson refers to United States civil rights leader who led a national campaign against racial discrimination and ran for presidential nomination (born in 1941). See Jesse Jackson meaning in Malayalam, Jesse Jackson definition, translation and meaning of Jesse Jackson in Malayalam. Find Jesse Jackson similar words, Jesse Jackson synonyms. Learn and practice the pronunciation of Jesse Jackson. Find the answer of what is the meaning of Jesse Jackson in Malayalam.
Other languages: Jesse Jackson meaning in Hindi
What is Jesse Jackson meaning in Malayalam, Jesse Jackson translation in Malayalam, Jesse Jackson definition, pronunciations and examples of Jesse Jackson in Malayalam.